package com.dingding.service.rentsale.core.sql;

/**
 * @Description:以租代售活动的sql
 * @author fengshuonan
 * @date 2016年7月20日 上午10:21:29
 * @version 叮叮搭车
 * @since 2.3.2
 */
public class RentSaleCarSql {

	// 获取以租代售订单的hql
	public static final String GET_RENT_SALE_CAR_ORDER_HQL = "SELECT carinfo.rcId AS carType,carinfo.carName AS carTypeName,rso.createTime AS orderCreateTime,c.cityName AS city,rso.orderStatus AS orderStatus FROM rentsalecarorder rso "
			+ "INNER JOIN rentcarinfo carinfo ON rso.vehicleId = carinfo.rcId "
			+ "INNER JOIN city c ON rso.cityId = c.cityId" + " WHERE rso.loginId = ?";
}
